Release 10.1A: OpenEdge Development:
AppBuilder
Defining and editing queries using Query Builder
A central step in developing any database application is creating the query or queries to be used for retrieving records from the database. AppBuilder offers a structured query editor for your use. You can invoke Query Builder in a number of ways:
- Define a new SmartDataObject — AppBuilder then starts the SmartDataObject Wizard, and the wizard calls Query Builder on your behalf. SmartObjects are the most powerful way to use queries.
- Place a basic Data Browser (Browse) object in the workspace — AppBuilder starts Query Builder. The browse object has all the internal logic necessary to use the query, though only in a self-contained way. You manually add any additional logic you require.
- Place a Query object in the workspace — AppBuilder then starts Query Builder. Such a query object is not connected to anything after you define it. You must manually add the code to make use of it.
Note: You can construct or modify queries by hand, using AppBuilder’s Section Editor, but such queries cannot later be edited using Query Builder. If you wish to have all queries be maintainable in Query Builder, you would have to replace any such free-form queries with their Query Builder-generated logical equivalents.- Choose the Query button from the property sheet of a frame object — AppBuilder then starts Query Builder. As is true of the query object, you must manually write the code that makes use of this embedded query, after you have finished defining it.
Query Builder always starts in Table-selection mode.
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |